EMT Practice Test

1. Question Content...

---

Question1: Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?

Question2: When does space reclamation for a column-organized table normally occur?

Question3: Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?

Question4: Which statement about expression-based indexes is true?

Question5: In which type of database are column-organized tables supported?

Question6: An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?

Question7: What type of table can be converted into a column-organized table with the db2convert command?

Question8: Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?

Question9: Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?

Question10: Which statement regarding NOT ENFORCED unique constraints is true?

Question11: When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

Question12: What will cause the creation of a column-organized table to fail?

Question13: What is a DB2 Advanced Copy Services (ACS) script used for?

Question14: When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?

Question15: What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?